﻿<cfscript>
/** 
* ORM CETStatusSubjectGrade
* 
* @hint "Hibernate persistenter MV_SBJ_GRADE_CET_STATUS. 各年级专业四六级过级率分析 物化视图" 
* 
*/ 

component 
	displayname="public.service.orm.senate.CETStatusSubjectGrade" 
	output=false 
	persistent=true 
	selectBeforeUpdate=true dynamicInsert=true dynamicUpdate=true 
	cacheuse="read-only" 
	entityname="CETStatusSubjectGrade" 
	table="mv_sbj_grade_cet_status"
	{
	
	property type="string" name="ExamID" column="exam_id" fieldtype="id" generator="assigned" hint="考试代码";
	property type="string" name="InstituteID" column="institute_id" fieldtype="id" generator="assigned" hint="部门代码";
	property type="string" name="SubjectID" column="sbj_id" fieldtype="id" generator="assigned" hint="专业号";
	property type="string" name="Grade" column="grade" fieldtype="id" generator="assigned" hint="年级";
	
	property type="string" name="InstituteName" column="institute_name" hint="部门名称";
	property type="string" name="SubjectName" column="sbj_name" hint="专业名称";

	property type="numeric" name="AvgScroll" column="scroll_avg" hint="平均分";
	property type="numeric" name="HighScroll" column="scroll_high" hint="最高分";
	property type="numeric" name="LowScroll" column="scroll_low" hint="最低分";
	property type="numeric" name="StudentTaken" column="student_taken" hint="参考人数";
	property type="numeric" name="StudentPassed" column="student_passed" hint="通过人数";
	property type="numeric" name="StudentGood" column="student_good" hint="优秀人数";

}

</cfscript>